package com.ruoyi.system.mapper;

import com.ruoyi.system.domain.EmployeeAssessmentDetail;
import com.ruoyi.system.domain.dto.EmployeeAssessDetailVO.Indicators;
import com.ruoyi.system.domain.dto.EmployeeAssessDetailVO.Top;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author Lenovo
* @description 针对表【employee_assessment_detail(员工考核详情表--Dmy)】的数据库操作Mapper
* @createDate 2025-06-07 09:58:26
* @Entity com.ruoyi.system.domain.EmployeeAssessmentDetail
*/
@Mapper
public interface EmployeeAssessmentDetailMapper {

    int deleteByPrimaryKey(Long id);

    int insert(EmployeeAssessmentDetail record);

    int insertSelective(EmployeeAssessmentDetail record);

    EmployeeAssessmentDetail selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(EmployeeAssessmentDetail record);

    int updateByPrimaryKey(EmployeeAssessmentDetail record);

    //查询top
    Top  selectTop(int employeeId);
    //查询职员id的最终平均分
    Double selectFinalScore(int employeeId);

    //查询职员id的所有指标
    List<Indicators> selectIndicators(int employeeId);
    //根据员工id删除
    int deleteByEmployeeId(int employeeId);

    //根据员工id更改状态
    int updateStatusByEmployeeId(@Param("employeeId") int employeeId, @Param("status") String status);

    //根据员工id和更改最终分数
    int updateFinalScoreByEmployeeId(@Param("employeeId") int employeeId, @Param("finalScore") Double finalScore);


}
